Tabela Price

Definicja tabeli Price

Name

Price

Code

Price

Comment

 


Lista kolumn tabeli Price

Name

Code

PriceID

PriceID

ServID

ServID

ResourceID

ResourceID

StartDT

StartDT

StopDT

StopDT

Price

Price

Discounts

Discounts

SWWSymbol

SWWSymbol


Kolumna PriceID tabeli Price

Definicja kolumny PriceID tabeli Price

Name

PriceID

Code

PriceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli Price

Definicja kolumny ServID tabeli Price

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli Price

Definicja kolumny ResourceID tabeli Price

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Price

Definicja kolumny StartDT tabeli Price

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Price

Definicja kolumny StopDT tabeli Price

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Price tabeli Price

Definicja kolumny Price tabeli Price

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Discounts tabeli Price

Definicja kolumny Discounts tabeli Price

Name

Discounts

Code

Discounts

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SWWSymbol tabeli Price

Definicja kolumny SWWSymbol tabeli Price

Name

SWWSymbol

Code

SWWSymbol

Data Type

CHAR(24)

Mandatory

No

Comment

 


Lista kluczy tabeli Price

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Price

Definicja klucza Identifier_1 tabeli Price

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment